package com.personal.system.mapper.act;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.personal.system.entity.approval.ApproveDetail;
import org.apache.ibatis.annotations.Update;

public interface ApproveDetailMapper extends BaseMapper<ApproveDetail> {

    @Update("UPDATE approve_detail " +
            "SET APPROVAL_SORT = APPROVAL_SORT + #{approvalSort} " +
            "WHERE find_in_set(APPROVAL_STATUS , #{approvalStatus}) AND APPROVE_NO = #{approveNo} ")
    int updateSort(int approvalSort, String approvalStatus, String approveNo);

}
